package com.onlyforfun.exchange.dao;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class BocDatabaseHelper extends SQLiteOpenHelper {
	
	public BocDatabaseHelper(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}

	public static final String TABLE_TIMEPRICES = "timeprices";
	public static final String COLUMN_ID = "_id";
	public static final String COLUMN_SPOTPURCHASEPRICE = "spotPurchasePrice";
	public static final String COLUMN_CASHPURCHASEPRICE = "cashPurchasePrice";
	public static final String COLUMN_SPOTOFFERPRICE = "spotOfferPrice";
	public static final String COLUMN_CASHOFFERPRICE = "cashOfferPrice";
	public static final String COLUMN_SAFEPRICE = "safePrice";
	public static final String COLUMN_BOCDISCOUNTEDPRICE = "bocDiscountedPrice";
	public static final String COLUMN_PUBLICTIME = "publicTime";
	public static final String COLUMN_NAME = "name";
	
	 // Database creation sql statement
//	  private static final String DATABASE_CREATE = "create table "
//	      + TABLE_TIMEPRICES + "(" + COLUMN_PUBLICTIME
//	      + " date primary key, " + COLUMN_COMMENT
//	      + " text not null);";

	private static final String DATABASE_NAME = "bocexchange.db";
	private static final int DATABASE_VERSION = 1;

	@Override
	public void onCreate(SQLiteDatabase database) {
//		BocTable.onCreate(database);
	}

	@Override
	public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
//		BocTable.onUpgrade(database, oldVersion, newVersion);
	}

}
